UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vWqjSF5YS1Xx90c7/LmKOP8AzbmOMU6ggJIP0r/2VC8='
WHERE
key_id = 'c765915e4ede65ff301c7ed8545fae5310e2789c0650790795aa7aa747000429'
AND (
token = 'vWqjSF5YS1Xx90c7/LmKOP8AzbmOMU6ggJIP0r/2VC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)