UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D6R6DZuYqIreyq5YyqYSoBXG0HsCDusQXAm5H9E0fj8='
WHERE
key_id = '0d3a60ec26540d2657b4c205dc4c713d109270e3f3913bbf49ff7b75336ab139'
AND (
token = 'D6R6DZuYqIreyq5YyqYSoBXG0HsCDusQXAm5H9E0fj8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)