UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TTeOSJdf1Rw+YFx7vBdd0o+/2CNyWXjdDZan9V02kOI='
WHERE
key_id = 'b2b28e9b85e1b5790a18357170bba48ebbdaa3f5546adf2b34d5196ceb46c2b6'
AND (
token = 'TTeOSJdf1Rw+YFx7vBdd0o+/2CNyWXjdDZan9V02kOI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)