UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4abjtvhgtamgx+5mpoUWyUVCH1bDLTX6f4J5eAprc3I='
WHERE
key_id = '3d70a8b47be92842880e3af74ea087e644354c29117d55faf4ebb66331dd1b4e'
AND (
token = '4abjtvhgtamgx+5mpoUWyUVCH1bDLTX6f4J5eAprc3I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)