UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iA+epI43NqSgeNe00Ma5FHxh1DOyo/soE1+Q5TOgwn0='
WHERE
key_id = 'b06ae22ff6306af27dab987d8098d1a53df7004c5addfd2319ab67323ed8c1f5'
AND (
token = 'iA+epI43NqSgeNe00Ma5FHxh1DOyo/soE1+Q5TOgwn0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)