UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KQSW3HhrlzkKy44SXn8FoC1h52TAvyn7cAggQrGrP78='
WHERE
key_id = 'f555f6b7197ad48b50f1944537320b3bd9f7ef549a79a1b43407e9fb041853c2'
AND (
token = 'KQSW3HhrlzkKy44SXn8FoC1h52TAvyn7cAggQrGrP78='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)