UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CoZRQbCeRUVw7A+xN9Uw59ABbJVeTVp06zEt4awUi6c='
WHERE
key_id = '97ff51374ad129e0efc7f04ee857cf715f4da537f7c3a0eb457bc2951ed5c7be'
AND (
token = 'CoZRQbCeRUVw7A+xN9Uw59ABbJVeTVp06zEt4awUi6c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)