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