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