UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mexQUPM9jstL3yXlTChhM72gIlwfrA89kVSYJwXUWEQ='
WHERE
key_id = 'e37f47f4a609ee769c92445887cdcf8dc9b3e83d3f315fc629142c845c89936f'
AND (
token = 'mexQUPM9jstL3yXlTChhM72gIlwfrA89kVSYJwXUWEQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)