UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o6kY/APG4aOzi/nYcvvtGb54GAscbHjPY/BRA1rt/3U='
WHERE
key_id = '307b0ebbf1e15fcb43ca45d35ea9ce11a3b665b4828e72fe90480c686c0cf349'
AND (
token = 'o6kY/APG4aOzi/nYcvvtGb54GAscbHjPY/BRA1rt/3U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)