UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zg4Ji9do0S+d/1al2lVzElrRsjf4t3959SMYOVD/U8I='
WHERE
key_id = '1e3c285a329ad5477732aa9484c828a986f6e8cc848d19bfb8864949ef7c4fb4'
AND (
token = 'Zg4Ji9do0S+d/1al2lVzElrRsjf4t3959SMYOVD/U8I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)