UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '55iLjYyUhKBNM3jrM3M5p4vIuqT+j+TeVm+mJdzPeB8='
WHERE
key_id = '6da31ea6df9c236cb1dd5d677b4810c178ba42661328f4746163006ea107a49b'
AND (
token = '55iLjYyUhKBNM3jrM3M5p4vIuqT+j+TeVm+mJdzPeB8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)