UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aNmHwlZKS7fdtFYKtMCN1bMwg2UWISa0sw0qdr4NwOk='
WHERE
key_id = '46a47461d0045bb4562d800e9b00a8ded480d0e0c42f44e890a46f73f8ff1460'
AND (
token = 'aNmHwlZKS7fdtFYKtMCN1bMwg2UWISa0sw0qdr4NwOk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)