UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YRz6B9cFKg3BJadZ3IwU+7ACB16FWb/rD7eZdDFicUc='
WHERE
key_id = '1899dac64a2c622cabf0d7eb90d136d103a5be1416d39cbc59fba45259fe3ea4'
AND (
token = 'YRz6B9cFKg3BJadZ3IwU+7ACB16FWb/rD7eZdDFicUc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)