UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/XK8liZ+6nmjpkc0xp5VJqEP2uMP7Sn5vyVG88RtS8E='
WHERE
key_id = 'c46c08884d65731e2478378ecfafdc4571f3c6210e49f3764ddd57b9dfeb0215'
AND (
token = '/XK8liZ+6nmjpkc0xp5VJqEP2uMP7Sn5vyVG88RtS8E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)