UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SFoAauy3N9Wl9o++EFzltIWNz05HXX7zs24VZ6+A/dM='
WHERE
key_id = '507a0365e0e210ce682b88f73b0f302e3af78a98a361cf991c7126f19c709914'
AND (
token = 'SFoAauy3N9Wl9o++EFzltIWNz05HXX7zs24VZ6+A/dM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)