UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6775mToYkt31KyhWOs64CyKNc9PUFbb/40OoOY4Pnuw='
WHERE
key_id = 'd075ce40f54bc4b0db92d72a94ada3b973beb3054858cf67a02aa9115232cf29'
AND (
token = '6775mToYkt31KyhWOs64CyKNc9PUFbb/40OoOY4Pnuw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)