UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jaNY2uS8HgHse0B491kA43yUH9BXkwezKycN7YcUm4o='
WHERE
key_id = 'bba0e5b2d30ce956c182d3fe48cfc1e2d34e5a4029ab4a433f8eb4718683b2ea'
AND (
token = 'jaNY2uS8HgHse0B491kA43yUH9BXkwezKycN7YcUm4o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)