UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ok67PUTbxVJbHqHiMucFTGyZEdQUozOpNZeerYmd7q0='
WHERE
key_id = 'd1b604d40a6dc39bbe7aca0c29c4f84a8e2afccab93ef945015cb22e616df755'
AND (
token = 'ok67PUTbxVJbHqHiMucFTGyZEdQUozOpNZeerYmd7q0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)