UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZF9e1lmG1WRacL/Bq5FIxbDX/pocfYevgK1GO5W6HZM='
WHERE
key_id = 'c0eebd525ad3f4bca4b8cb4704c920dfeb39fea2cf4bee6db012606472ffa9df'
AND (
token = 'ZF9e1lmG1WRacL/Bq5FIxbDX/pocfYevgK1GO5W6HZM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)