UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S0WGfcNM1145uKpnEDZBKTjNlc8BpeaHYdLV1ijcRYo='
WHERE
key_id = '5f401b7b7f5be092f447c6bfa4d7b87d0e03bb36280322f15a380946858e616a'
AND (
token = 'S0WGfcNM1145uKpnEDZBKTjNlc8BpeaHYdLV1ijcRYo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)