UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ztr16UCcY5SvGFcRHLu5edI6tXDbJXotAcY0Y/5ek1s='
WHERE
key_id = 'd56214fb191d1f82571cffa774f8a310445748c209328d5ebf50324717e8f427'
AND (
token = 'Ztr16UCcY5SvGFcRHLu5edI6tXDbJXotAcY0Y/5ek1s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)