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