UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TD0SCFpmab3KW0mI1aTs8+jEDT+8TMoNPgbpRff/xSE='
WHERE
key_id = 'f4f5affdc910aa704d4fef99106775b5447ddcb9da5af5df83bad39b6fba6db1'
AND (
token = 'TD0SCFpmab3KW0mI1aTs8+jEDT+8TMoNPgbpRff/xSE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)