UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A8OKUTWnk5HnRFWIJHa6WojkdvDWliqfCKA4YbEMU8o='
WHERE
key_id = '3a667f23c58cba3611d8ea57f309173ed03dd24535f1e811eaefbfe2bd45bf6b'
AND (
token = 'A8OKUTWnk5HnRFWIJHa6WojkdvDWliqfCKA4YbEMU8o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)