UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9hgVx436Ih4iU3IWd0fYm9FlfM91AsiTmvH5TG7UTH8='
WHERE
key_id = 'b62891a766f75f199d2aebc512fb77327518a8cdaabf58646ac0f2d989fa57c7'
AND (
token = '9hgVx436Ih4iU3IWd0fYm9FlfM91AsiTmvH5TG7UTH8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)