UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aaX2wsG8lS8Bfb6OnuQcWkYXXwWLFc34xzHQHrKgqw8='
WHERE
key_id = '2979ecf163066882edba47d1a0fa81d0181afea555ef93cb5f30e76fc4c7ab59'
AND (
token = 'aaX2wsG8lS8Bfb6OnuQcWkYXXwWLFc34xzHQHrKgqw8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)