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