UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G9Hv7TtXZWvsqNatTpr9PpgBGhEFfOVulKtgKgrKDy4='
WHERE
key_id = '6fa0e64659b90ea110fdd4ba3b767d4799a685903f8146a46a18b5211c3485aa'
AND (
token = 'G9Hv7TtXZWvsqNatTpr9PpgBGhEFfOVulKtgKgrKDy4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)