UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zEy4zcIKHRk9jhV6wvFbU2dDjHM7h5pE6AN61wN5HAI='
WHERE
key_id = '8670fcd4ace5095be13b2b2de84ae969e2b3dca1c9cf9edad36205dc977c006a'
AND (
token = 'zEy4zcIKHRk9jhV6wvFbU2dDjHM7h5pE6AN61wN5HAI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)