UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OOzgq8WJwbSunWTbJzhAZ40WMRH+VxkMLrZslrtG/8w='
WHERE
key_id = '87b78751a97ec68d94221b5c3f74ae07e0ad1ec12e55bcb8ba8443381a8cfcda'
AND (
token = 'OOzgq8WJwbSunWTbJzhAZ40WMRH+VxkMLrZslrtG/8w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)