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