UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/j3ANzsh67c7Xa5ua1pRWBjoFCESslPAu5Y0Y0BlefA='
WHERE
key_id = '1c6531ae33b0247945dd35ba3e7229729e665cb7693eaf20eef080a2c6289328'
AND (
token = '/j3ANzsh67c7Xa5ua1pRWBjoFCESslPAu5Y0Y0BlefA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)