UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0k4lyaBs3XypPGmtqDi3PPiE2uLZxJtPe9Yp0/sORQw='
WHERE
key_id = 'c6aa62db34b54e16e63174ea1630eaa69a48bc8d7cbcde72746f4a118515f959'
AND (
token = '0k4lyaBs3XypPGmtqDi3PPiE2uLZxJtPe9Yp0/sORQw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)