UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ziU5N5LvYP5K2RhOIWeGXgTn1r6NcTAUk1rbISkRHYY='
WHERE
key_id = 'e9411b49f2482b18f119b47b9b1ab8482bb5b3d94523ee5c420d0778b4850a76'
AND (
token = 'ziU5N5LvYP5K2RhOIWeGXgTn1r6NcTAUk1rbISkRHYY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)