UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8wmDugWncGkbo0L8v00QH4Lmatv1HqhY94Ma0mJJqrQ='
WHERE
key_id = '1e58cf6884346bc78db8ba22665f21a03b6e6f659114d5e4978a9d1c3b48bbe9'
AND (
token = '8wmDugWncGkbo0L8v00QH4Lmatv1HqhY94Ma0mJJqrQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)