UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'scnbd6psSV6MGB17ilmkilEwpvgeOvB8+MuuM+kAVhE='
WHERE
key_id = '8b01d3286c7d2519d6f6c622c9dcae2866ad6a9b31751e2729ad78876d4fde30'
AND (
token = 'scnbd6psSV6MGB17ilmkilEwpvgeOvB8+MuuM+kAVhE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)