UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '59gRvzWqhSS4s0HF4ClCmE77AV2/EjGzmveIV5CSXnA='
WHERE
key_id = '0d8fd87bba33c17dca833cb90c2b1a5aef3f943a796ed14bff1714b165ad2e87'
AND (
token = '59gRvzWqhSS4s0HF4ClCmE77AV2/EjGzmveIV5CSXnA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)