UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nJ194S5aiXcpcEnubVc7ecmfQ4F1xLDiMwq9S8AoUew='
WHERE
key_id = '792f3763fc3a4892376a8453bf249ef3a15c56e98e4171aa2191ffb50957f069'
AND (
token = 'nJ194S5aiXcpcEnubVc7ecmfQ4F1xLDiMwq9S8AoUew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)