UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zoDgkSvG5jayZuA62XgwwKKSb3JbJk6t/chlCiiA4k4='
WHERE
key_id = 'c83068e942bef23a91923cf20d5f40b2675e2a17ff49cc95a6cb43cbe33e8e71'
AND (
token = 'zoDgkSvG5jayZuA62XgwwKKSb3JbJk6t/chlCiiA4k4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)