UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cadxvBmzfY9CxjEHI2iUwJzmc0QnGXWzARqdr9/tu5g='
WHERE
key_id = 'b9af5a4c37bfa79df646a4a1060a098a10efbfeeaf9bafa5c2d39f14086269f3'
AND (
token = 'cadxvBmzfY9CxjEHI2iUwJzmc0QnGXWzARqdr9/tu5g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)